UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XAx6s7h1tzbklEva9p7wcO7s2I8+n0QwPVXtH+xupdo='
WHERE
key_id = 'c1cd1159e9ca40f8ca4f8283241557d2882e3b72a1b26b48d5b1f8e9cd0fd276'
AND (
token = 'XAx6s7h1tzbklEva9p7wcO7s2I8+n0QwPVXtH+xupdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)