UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZ0q4gHIp/0ZWDT1J9aHA1lpcfHEwNIjNGI2B2PUUV8='
WHERE
key_id = 'b1147d25f96938e183f69009f1b45331ecc5a80931cb124985bd294e2143dac7'
AND (
token = 'ZZ0q4gHIp/0ZWDT1J9aHA1lpcfHEwNIjNGI2B2PUUV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)