UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jtfnHdFcgMSJCUZvREMrjieLZKyvO9YMwnx1gz9onX0='
WHERE
key_id = '6c12311bd643bf45eecdeb15f25113fe02dd503ef82bd28cc95355597a5ed3aa'
AND (
token = 'jtfnHdFcgMSJCUZvREMrjieLZKyvO9YMwnx1gz9onX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)