UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b8SXeW32ppezYslGpUVt7mMFLjMxeRUA9bNM1X4lTr8='
WHERE
key_id = 'e2940e9ee1a9a556a240e7e13ce93cd65c6a9e74189cb3f0a1bbdcac7ad59ef1'
AND (
token = 'b8SXeW32ppezYslGpUVt7mMFLjMxeRUA9bNM1X4lTr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)