UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qX99LDVgqT0WyHboHwa1htGafWtSGd9ejovbOvbH2g='
WHERE
key_id = '09f6711fc25e70cc670324549798770c8d04a2a38c71707b7fb467b125beddee'
AND (
token = '8qX99LDVgqT0WyHboHwa1htGafWtSGd9ejovbOvbH2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)