UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b0+zlHPC5QElX8YoVnEJFwzqSoSEMcNGhNfkqaBB/D4='
WHERE
key_id = '12e5bf408c9cf8220538993a42ece37a4647f1f7e393324c488d6003818f995f'
AND (
token = 'b0+zlHPC5QElX8YoVnEJFwzqSoSEMcNGhNfkqaBB/D4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)