UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CccgqehPd4dMqqn5bBACLj0UWylZFrwymbXZ09IjFgA='
WHERE
key_id = 'f7a74a53101a1d9bd9091280906b7e141cbd2929dc68f6a18ff0ad824a26bcda'
AND (
token = 'CccgqehPd4dMqqn5bBACLj0UWylZFrwymbXZ09IjFgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)