UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jD+76FkPLFw5jm7nm8U8G2Nn/JdCUzUKSci+lXnwgLs='
WHERE
key_id = '8c0625413ec0a47e298d1bfb7b7401a08c24461ee4d1ac54282214b6fa4c9ffe'
AND (
token = 'jD+76FkPLFw5jm7nm8U8G2Nn/JdCUzUKSci+lXnwgLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)