UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fy647jMiUARERbmzwiFm/Bd8J6+3JIRGS4wK2/PyoA='
WHERE
key_id = 'a0e52c1881423ed55043ee9303a72fd075e482374b5a9e46bf01dae2713dc599'
AND (
token = '0fy647jMiUARERbmzwiFm/Bd8J6+3JIRGS4wK2/PyoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)