UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gj3XHSiZEm2+AgV04PMj7zDH2ZnEZVh4kLcd95gH9R8='
WHERE
key_id = '3e7b1585625f9c3e637a233a502ffa5c604e0f9030f7e4eaf358ebb6b317884c'
AND (
token = 'gj3XHSiZEm2+AgV04PMj7zDH2ZnEZVh4kLcd95gH9R8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)