UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Pc0Cowb1Do4NGJDk2tIIOfDrnXt4/RCAk3Bh5S3N+8='
WHERE
key_id = '7a83a82ee9db0885265dacb2ef4220cf10b9cca87211b5ae96e7e4d1bdfe0d6a'
AND (
token = '1Pc0Cowb1Do4NGJDk2tIIOfDrnXt4/RCAk3Bh5S3N+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)