UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pIooLAz6EPUlOy560wG5+H0WO022xZLlUNF1M8sZiac='
WHERE
key_id = 'c1ca3f44472a909f993570a069ecbdfe4d1fce809720e5be08d7ee07b3c4cae7'
AND (
token = 'pIooLAz6EPUlOy560wG5+H0WO022xZLlUNF1M8sZiac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)