UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FgP2d8pMBg8MAmM71y8BBIO/iWB0pSEME9ZbOIJ9QHA='
WHERE
key_id = '80b9c4cb6d61f41cf581320f6c717ee9cd3b12be456b1dc83fc4f10849e1c3a7'
AND (
token = 'FgP2d8pMBg8MAmM71y8BBIO/iWB0pSEME9ZbOIJ9QHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)