UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'majRw8DE4WEiACHgaRmeNv6hUw8ovyAlBt/yMJ9fIlY='
WHERE
key_id = '0e578735d37d3dc978c70299c9622b9edb9bbbef458137a2a29bd51648b86e7a'
AND (
token = 'majRw8DE4WEiACHgaRmeNv6hUw8ovyAlBt/yMJ9fIlY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)