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