UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TAqRDtpBJuzxneTh9tdGeNFCX9UvETOSs7NrglGH+V8='
WHERE
key_id = '40dbf2d1c69b64c0b770d632864fef6dc8303748c35b144bfae0a8bc101caaaf'
AND (
token = 'TAqRDtpBJuzxneTh9tdGeNFCX9UvETOSs7NrglGH+V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)