UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ODJ9X03nZM7LaOCyth7Ye+BKzCPvNpDxgY25TffMpqg='
WHERE
key_id = 'f6f9401d6413530472cd0f57545e807576f1ffd0063b429c97877e013d12a600'
AND (
token = 'ODJ9X03nZM7LaOCyth7Ye+BKzCPvNpDxgY25TffMpqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)