UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IEY5XKJLhJdTXb7eHnhQ9yM+Z33PSAFA123MXM9b5SQ='
WHERE
key_id = 'a8ed5d9eb9468ca893b1ccf31b27f59a46da4d21d4938354da9ece47844156ab'
AND (
token = 'IEY5XKJLhJdTXb7eHnhQ9yM+Z33PSAFA123MXM9b5SQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)