UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5LxcT/rrNG1HIoEmOrQSdMTSoPlYCAsgaciWoz6XFHk='
WHERE
key_id = '4e99145135ebc807e828f329080940aa58db3fa8858f48a94abfac613df026f3'
AND (
token = '5LxcT/rrNG1HIoEmOrQSdMTSoPlYCAsgaciWoz6XFHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)