UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's7FiMZw5tlyi1NeHkiK2Y89SyZ8hg6A82toSkYw92ts='
WHERE
key_id = '16cba7ecc8ce991224c59d7a449add2e4813e66f8f07511e25f2e5216888ac70'
AND (
token = 's7FiMZw5tlyi1NeHkiK2Y89SyZ8hg6A82toSkYw92ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)