UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0CiUfkD64R75c2FajsmIQ4vOoyvnJdq7BM9RNORZ5Zk='
WHERE
key_id = '31c69a61faf2f9db2db9dacf4ecbf8da39e0e028f13a4831e74dd0c8f8686bb4'
AND (
token = '0CiUfkD64R75c2FajsmIQ4vOoyvnJdq7BM9RNORZ5Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)