UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ca8D2sGiIgRkhz1Jbj7ooGlZ/Bd46fi6/0RJAHGVjb4='
WHERE
key_id = '4309698f2f3e440daa1d2a210ee7bc327ba736b5f0ec91a10869dfc04914b03a'
AND (
token = 'Ca8D2sGiIgRkhz1Jbj7ooGlZ/Bd46fi6/0RJAHGVjb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)