UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yMmG1yMH8izuTAKzBtUpBYoiN+n6o2/dQ9YbG132j3A='
WHERE
key_id = 'a504e56f7d3905efe490d26012b9eaea4eb620e38de77326a666a22ce83146ab'
AND (
token = 'yMmG1yMH8izuTAKzBtUpBYoiN+n6o2/dQ9YbG132j3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)