UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5pX20xhdcivRnHo3B2FUXyIkBJiyvcLsFE8VDtlUGz4='
WHERE
key_id = '79c0ca8bdeca8226400cbaa01ea3394d829ae06132f8bece8ac15491e6f60ce0'
AND (
token = '5pX20xhdcivRnHo3B2FUXyIkBJiyvcLsFE8VDtlUGz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)