UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D/CIo970p9HYmAd+jARzc7C/XfmzVsEBGP01oAkvcvE='
WHERE
key_id = 'e7f27d1c53fe5406e9a62250d7b49131e101dc142dd265dbf15a12a1123abf98'
AND (
token = 'D/CIo970p9HYmAd+jARzc7C/XfmzVsEBGP01oAkvcvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)