UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXJqyLaVBz77G1Nk3eRt0vxAIFV6923i/qsuJAeN+dg='
WHERE
key_id = 'd1caea9e82a629b55f0ab2c2cc5dbefda25edeae2bf5ede7f99715a6c40b7377'
AND (
token = 'cXJqyLaVBz77G1Nk3eRt0vxAIFV6923i/qsuJAeN+dg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)