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