UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ks/xXsckIwLx8LcCtRvODyd01LX6W0MA6eR5zuzg/rk='
WHERE
key_id = '0ceaedb24b3a4f317bedda350068167eecf8564a37b6ec156197a0d6ce3104d0'
AND (
token = 'ks/xXsckIwLx8LcCtRvODyd01LX6W0MA6eR5zuzg/rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)