UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xlFou6kcV7MLTPW3LilakGAyJ9zvduoN3Y0uoa1PoOU='
WHERE
key_id = 'f9562037254e5f29970dbee4cb90436ef228df32b6c58c5ba7a5ec34def3aa31'
AND (
token = 'xlFou6kcV7MLTPW3LilakGAyJ9zvduoN3Y0uoa1PoOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)